Conditional query ?

  • Note

    
                    $this->db->select('*');
                    $this->db->from('users');
    
                    $name=$this->input->post('name');
                    if(!empty($name)){
                        $this->db->where('name', $name );
                    }
    
                    $mobile=$this->input->post('mobile');
                    if(!empty($mobile)){
                        $this->db->where('mobile', $mobile );
                    }
                   
                    $query = $this->db->get();
    
                    $result= $query->result();